<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_brand`;");
E_C("CREATE TABLE `ecs_brand` (
  `brand_id` smallint(5) unsigned NOT NULL auto_increment,
  `brand_name` varchar(60) NOT NULL default '',
  `brand_logo` varchar(80) NOT NULL default '',
  `brand_desc` text NOT NULL,
  `site_url` varchar(255) NOT NULL default '',
  `sort_order` tinyint(3) unsigned NOT NULL default '50',
  `is_show` tinyint(1) unsigned NOT NULL default '1',
  `brand_banner` varchar(80) NOT NULL COMMENT '商品品牌banner',
  PRIMARY KEY  (`brand_id`),
  KEY `is_show` (`is_show`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_brand` values('91','OVATION','','OVATION的测试描述','http://','50','1','');");
E_D("replace into `ecs_brand` values('90','大昌食品','1420420921037645655.jpg','大昌测试描述','http://','50','1','');");
E_D("replace into `ecs_brand` values('89','DELICA','','','http://','50','1','');");
E_D("replace into `ecs_brand` values('88','百年栗园','1420420464982194050.jpg','百年栗园描述测试','http://','50','1','');");
E_D("replace into `ecs_brand` values('87','大昌食品-烹烹享','','','http://','50','1','');");
E_D("replace into `ecs_brand` values('86','知牧','','','http://','50','1','');");
E_D("replace into `ecs_brand` values('85','福成','','','http://','50','1','');");
E_D("replace into `ecs_brand` values('84','精气神','','','http://','50','1','');");
E_D("replace into `ecs_brand` values('83','天玛生态','','','http://','50','1','');");
E_D("replace into `ecs_brand` values('82','皇上皇','','','http://','50','1','');");
E_D("replace into `ecs_brand` values('81','天谱乐食Tender Plus','','','http://','50','1','');");
E_D("replace into `ecs_brand` values('80','科尔沁','','','http://','50','1','');");

require("../../inc/footer.php");
?>